//Figure 3: Scenario Traceability
//Author  : Sriram Rajagopalan

//Configurations
Table TestConfigurationEntries {
  Test_Configuration_Id integer [pk]
  Test_Configuration_Set_Id integer
  Project_Group_Id integer  
  Note: 'Stores Product Specific Test Configurations'
}

Table TestConfigurationSets {
  Test_Configuration_Set_Id integer [pk]
  Project_Id integer
  Project_Group_Id integer
  Note: 'Stores Set of Product Specific Test Configurations'
}

//Test Sets
Table TestSets {
  Test_Set_Id integer [pk]
  Project_Id integer
  Release_Id integer
  Test_Run_Type_Id integer
  Test_Configuration_Set_Id integer
  Project_Group_Id integer
  Note:'Stores Test Set details without associated test cases'
}

Table TestSetFolders {
  Test_Set_Folder_Id integer [pk]
  Project_Id integer
  Project_Group_Id integer
  Note:'Stores Product Folder information for Test Sets'
}

Table TestSetIncidents {
  Test_Set_Id integer [pk]
  Incident_Id integer [pk]
  Detected_Release_Id integer
  Resolved_Release_Id integer
  Verified_Release_Id integer
  Note: 'Connects Produt Test Cases and Product Incidents'
}

Table TestSetTestCases {
  Test_Set_Test_Case_Id integer [pk]
  Test_Set_Id integer
  Test_Case_Id integer
  Project_Id integer
  Note:'Stores the relationship between Test Sets and Test Cases'
}

//Automation Hosts
Table AutomationHosts {
  Automation_Host_Id integer [pk]
  Project_Id integer
  Project_Group_Id integer
  Note:'Stores Automation Host Information for Test Sets'
}

//Minimal Releationships
//Configurations
Ref: "TestConfigurationEntries"."Test_Configuration_Set_Id" - "TestConfigurationSets"."Test_Configuration_Set_Id"
Ref: "TestConfigurationSets"."Test_Configuration_Set_Id" - "TestSets"."Test_Configuration_Set_Id"

//Test Sets
Ref: "TestSets"."Test_Set_Id" - "TestSetTestCases"."Test_Set_Id"
Ref: "TestSets"."Test_Set_Id" - "TestSetIncidents"."Test_Set_Id"
Ref: TestSetFolders.Project_Id - TestSets.Project_Id

//Automation
Ref: AutomationHosts.Project_Id - TestSets.Project_Id